package com.ruoyi.project.syl_LiBiao.mapper;

import com.ruoyi.project.syl_LiBiao.domain.OutpatientPatient;
import com.ruoyi.project.syl_LiBiao.domain.OutpatientPrescription;
import com.ruoyi.project.syl_LiBiao.domain.OutpatientRegister;
import com.ruoyi.project.syl_LiBiao.domain.PrOrReOrCa;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ChargeManagementMapper {


    PrOrReOrCa selectRegisterId(String registerId);

    @Select("select patient_name patientName from outpatient_patient where patient_id = #{patientId}")
    String selectOneOutpatientPatient(Integer patientId);

    @Select("select dept_name deptName from syl_dept where dept_id = #{deptId}")
    String selectOneDeptName(Integer deptId);
    @Select("select user_name doctorName from syl_user where user_id= #{doctorId}")
    String selectOneHisUser(Integer doctorId);
    @Select("select prescription_id prescriptionId,register_id registerId,case_id caseId,\n" +
            "medicine medicine,medicine_unitl medicineUnitl,medicine_num medicineNum,\n" +
            "medicine_price medicinePrice,medicine_notes medicineNotes,status status,\n" +
            "checkk as checkk,check_unit checkUnit,check_price checkPrice,check_notes checkNotes,\n" +
            "check_pay_status checkPayStatus\n" +
            " from outpatient_prescription where register_id= 'GH202103202044'")
    List<OutpatientPrescription> selectListPre(String registerId);
}
